SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402952 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402952 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850126,735905,772184,210157,975953,747227,743081,954693,447003,588684,436210,997350,746868,378063,467845,689638,722412,48757,546812,293512,210206,171428,725990,972989,899174,232258,999955,200579,838930,503014,144891,771547,762779,667053,492156,627002,761650,741865,1040407,416465,710449,699530,235127,771562,974331,328326,772217,544487,135157,288500,377847,898762,229336,186674,377856,621260,696596,188818,66643,587924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]