SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118808 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118808 [ RunTime:0.004626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830117,50141,407713,102736,279629,799589,794101,597940,391249,133999,425090,962222,687353,107935,1028052,482876,614855,738935,301156,822327,188158,352667,422299,944329,587034,516165,451698,819505,946503,1023385,887660,649601,853384,942570,577237,357977,332770,998316,743601,548323,861718,141307,118343,369108,224045,460437,902472,487431,565259,838029,957509,763417,1000920,962794,681901,1000293,265898,779343,34385,679620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]