SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402005 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402005 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978739,772483,590735,910055,301643,998855,75187,853248,686068,342880,428544,820426,205034,9095,619049,226564,21163,454104,1037900,935090,535892,454407,755227,657060,371650,860987,719961,895337,640579,864136,564525,7438,120092,1012303,569766,573407,669372,672117,1016054,515672,13118,1016974,415575,305393,817296,198931,889464,863213,362409,520349,381729,356530,64997,583584,399519,518004,515680,46928,38309,351919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003088s ]