SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 815679 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 815679 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511561,1016560,837168,485090,267081,331942,617591,662763,206901,232309,554846,56732,171161,672486,131241,408176,61874,1033561,504436,758405,1023483,599159,190467,981966,954344,1000927,279464,868003,1039283,841509,415580,263538,652446,912718,419923,127617,194653,442178,884088,1028208,165851,444361,638414,332408,711309,21402,535068,334149,325099,479857,931084,141917,231267,834900,322830,340348,883197,141137,335158,911876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 815679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 815679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]