SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550398 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550398 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899610,767780,386345,79575,548219,988616,409276,50909,186358,238507,140604,962023,913028,763197,538129,719877,167554,361113,930267,1033748,160981,1030699,694173,33129,515850,407995,630519,332081,627897,205593,336636,256174,816869,42054,613533,543493,424576,767096,825098,291258,456591,546623,696140,545530,44536,66856,265836,558270,730271,216276,103271,586017,1042861,423675,803426,922272,229146,34612,231674,750921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]