SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320080 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320080 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728844,749858,217977,462245,722242,80067,971357,161924,743571,612532,271309,64171,989135,989720,662590,152151,984492,645575,337513,991129,902847,768888,523522,771777,1016138,2465,698962,321234,928366,196326,203435,834603,932428,284818,164429,598803,430123,411413,636921,864180,894770,139916,228941,503852,1029970,123602,661692,990593,159995,1044290,75459,1011243,426326,26494,761816,62799,804412,654417,537430,560420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001128s ]