SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418051 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418051 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805331,497884,535879,231090,541402,144149,345356,878150,1008620,1008674,555695,728235,2762,531888,326486,487876,755396,998919,539594,73779,11035,845871,250645,1018355,313972,346322,884543,594201,472653,227924,579205,237695,522895,697463,24920,368828,524259,83370,306920,243265,969810,935177,987151,601139,192458,662714,129964,310306,358320,164939,185382,726058,1045270,425639,354256,1034379,59876,232440,23968,1010848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]