SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333383 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333383 [ RunTime:0.003554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559457,246614,3582,273659,206941,898318,450356,622269,157365,731117,499585,128313,690427,614584,902632,980927,642290,634599,356853,69309,740335,260053,612156,104211,214262,522382,1013469,24807,710246,994042,749721,140440,9133,493225,401663,982033,865295,313065,795221,977943,537333,895052,69240,531020,823751,316287,537264,55283,469588,430901,129914,319048,461308,362346,745409,848782,18349,377108,435262,697212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]