SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184111 LIMIT 1 [ RunTime:0.003923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184111 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703915,103431,264803,541922,116548,113173,260303,756628,147218,43216,615139,951099,496356,516903,371206,189351,445647,531400,1016344,1012466,550565,930868,600212,87729,85383,631966,280340,241722,178703,205857,166292,62390,789964,639431,1005840,7032,409234,428270,235714,490303,225638,976092,369940,161252,643458,875688,346000,123767,324060,64168,345379,454184,51870,383,761943,472485,871529,879819,227465,503333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000851s ]