SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000318 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000318 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837103,936742,835975,972307,722318,1020318,522178,254502,983569,465885,499861,951433,360508,23854,656266,763232,602632,962092,1000258,365402,744029,664780,212447,112059,479937,563385,198208,172991,308489,891091,236717,896019,902055,146523,14207,968132,145157,435445,116345,98555,544061,800817,422814,137337,337728,770676,760491,402435,230906,283309,183168,418781,97708,436742,356391,212420,139362,430257,295654,806548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]