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` = 263541 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263541 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368294,396851,23613,709952,51459,263336,521129,447017,186732,235208,75490,741354,322927,956780,286135,506887,434048,630051,72546,873953,98854,531790,958223,491663,139075,21693,342043,137851,278615,135906,613289,235143,718328,202050,453802,562658,929419,1041692,82503,504557,974079,979139,127679,445007,142925,37435,221536,511623,856593,848588,1012023,542915,414611,937236,567496,652435,751936,26967,302450,277850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]