SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451610 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451610 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472010,479187,673858,439012,829859,1043099,390076,782612,573470,399754,526033,776529,380303,195391,98642,899934,135155,1000321,790247,689170,580461,386946,802848,735668,506223,262952,535567,200743,975096,410573,641640,371324,620428,933568,185480,508385,936019,624704,165603,457603,799427,251775,979879,225165,60072,214444,67495,420165,168675,449196,423567,226087,533494,1005661,379384,223587,945144,812227,637668,382528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]