SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311982 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311982 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528979,610060,170291,273102,469459,235999,867666,880469,197716,44821,359786,936220,992083,698938,596297,761305,129833,299904,915070,996630,43440,363965,1001247,765740,650907,1048798,672175,686856,587598,656300,548353,367863,120872,443132,62476,616643,936010,1008362,380213,623690,495405,655784,657774,54328,620739,353802,258606,716305,762134,187406,248731,954092,94455,507023,374804,774326,497568,345659,280402,601946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001402s ]