SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912991 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912991 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509918,12079,1004233,525957,769266,226932,236660,614978,783087,911392,569449,358883,249775,434093,707776,648633,576603,19762,687931,750647,377245,630187,989159,150271,317010,249231,432412,798230,121279,555402,74149,397479,242115,819205,57325,752412,1021070,713415,932505,835201,147953,419628,127772,985610,324371,287249,733654,726165,82639,583470,283,85842,896275,428723,401467,301770,538624,203263,119081,773034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]