SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504925 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504925 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288988,150147,110765,707119,608532,141237,991323,186679,997659,317827,1002457,891639,409021,904734,684689,221359,742106,638389,14021,370171,380891,171604,736400,873151,501013,301446,268655,588072,200148,370984,50180,358117,94468,49290,221158,541637,269040,503867,627989,409471,316525,586134,239454,378870,537525,668925,228942,624628,147793,656174,214719,578028,386147,482352,578923,13346,459129,106923,42014,95647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]