SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017327 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017327 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242825,102612,83957,358213,1016780,263269,554191,1034258,706586,55569,747474,385512,840165,410983,496114,1000571,173659,907597,211442,323692,920884,812573,664233,850767,644832,193151,296856,286919,846519,210329,635896,473888,655851,401673,212187,487328,275720,1046212,563848,739400,984332,316212,280346,959604,579186,443229,650525,219772,100227,254682,659991,456126,715954,645054,472812,654990,193985,184766,170650,319253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]