SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560720 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560720 [ RunTime:0.002622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032041,100801,443028,175857,585839,240777,1033807,322609,679096,269309,673684,194688,931128,44910,143655,757144,256437,467045,883360,524362,430302,1046598,914398,484859,91871,739394,1036748,1024521,544060,101800,145903,603167,760565,407761,351975,6974,952413,853539,652877,565708,176734,978269,522849,896896,33778,265273,93256,718656,596029,769562,618363,1045446,546218,801192,664717,735929,144676,856395,298531,145997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]