SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 780313 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 780313 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422351,878723,695758,271321,134696,305386,942831,1026594,680431,763317,809650,908580,645698,399846,946471,814831,271516,221569,535144,697984,907676,572623,506978,399108,29218,498618,516347,183512,685735,144194,282780,356590,69299,344361,360768,243803,167302,1020675,485600,492993,980002,833519,973792,784110,343470,438728,1018052,945545,302516,50164,418952,904472,377850,271525,513403,603713,440256,157112,331521,1020368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 780313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 780313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]