SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444193 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444193 [ RunTime:0.004564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853044,649778,603236,924165,841973,667131,798419,369576,184197,294983,325514,128781,474924,551853,632694,460026,281136,341037,722459,331530,172736,925694,559265,890810,1040291,788963,811339,559060,781955,973270,1015254,1026700,264226,772975,703091,778099,10465,133810,57210,374448,394727,653087,708084,116313,179383,779084,394073,294100,362265,142752,720823,1042982,888966,470878,952465,397940,654096,881281,304995,29803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]