SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53343 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53343 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431943,266930,143899,124958,52196,782056,934428,518089,797173,1029503,894138,543732,258539,536330,796378,655942,648407,563238,1035898,1466,909050,598835,294233,806728,897468,241568,172481,1005754,114782,77899,444921,128163,327010,266565,503672,147954,966483,331682,1025027,391906,68423,300710,317963,714200,836752,1018818,346251,711168,708268,979313,376111,159639,921796,567276,818783,500247,100816,78984,326953,21500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]