SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521717 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521717 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722792,665490,1028546,119591,1033847,367217,377941,155487,34600,129862,169055,261549,789257,393864,268483,534335,83583,346807,251220,281990,820357,577760,399465,1014603,1004096,341871,488891,30505,208000,249906,36737,464354,228955,993534,656253,182076,299567,176747,634469,268938,386060,239543,1045696,10692,217339,779292,1045029,376455,60855,585438,13717,445069,868686,628206,484396,649558,46408,413927,888612,891247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]