SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293761 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293761 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019969,436111,80980,550580,405010,871181,482044,1000014,305137,882606,540980,111161,882219,966474,636836,699635,670123,563452,456902,384139,796740,671589,58012,286924,428499,86395,552901,210881,29282,138621,37993,691395,446198,893700,313205,919780,996537,529927,33193,397230,158128,1003733,1040133,957671,524350,410369,70945,299234,928203,942039,242323,956496,312422,188569,304191,742596,516150,352990,108404,675900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]