SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 133383 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 133383 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285009,1014112,361339,598963,842867,346450,649658,128401,461983,1044175,338181,1010008,229606,570624,330569,515229,9360,618844,144929,40336,1009934,494908,600101,254023,540672,677879,265871,322072,577381,311081,696324,1004539,236541,412381,686387,332248,666057,593732,928226,550393,943279,723283,272129,993287,58079,577032,729631,875195,556835,725443,580064,988736,517462,44321,683004,27673,803687,910843,539079,469629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 133383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 133383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]