SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343671 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343671 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520693,644372,557292,193410,473719,818713,1040204,290545,966223,959116,692856,791391,962863,440448,357938,556805,980346,209928,861473,353225,630717,637088,791782,129555,86823,521934,970663,470818,367265,1041096,1013838,17719,873140,799777,164249,172405,285853,168632,538825,26643,443916,221648,105497,564302,42780,463596,622196,315397,972677,962064,866363,492777,1043977,399057,203291,229678,894018,5586,999501,990120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]