SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477445 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477445 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633039,238487,838957,291529,79272,184461,211308,499102,84553,733654,117894,953919,924119,26717,641610,576098,529276,649641,695838,870432,249044,339842,234286,937116,171148,757015,657332,852933,10000,469068,762018,864022,998640,1024549,361513,84169,576725,642356,547063,300842,991362,201413,971769,68078,860880,492140,411792,537156,955300,536423,915442,194863,342497,909192,1040675,1010035,300911,101813,950216,675186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]