SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414603 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414603 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349950,250135,177998,447583,258108,108910,36044,465865,188052,358543,975155,481219,475814,410982,277700,145612,388443,772823,1046302,171769,1021,698378,259372,431263,694002,824284,284503,534732,983970,536713,400887,583891,268281,6806,736762,494547,1025749,398449,79580,600094,889083,734812,695604,901289,955273,808062,579169,301569,247399,168737,913149,392373,291810,375811,402784,949019,275940,532910,630908,607269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]