SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54153 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54153 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819514,772774,379266,881242,659376,191097,83337,379111,834298,580879,850538,311902,449442,399599,815962,289651,815037,464360,107971,362507,708397,710432,793017,963300,635762,418573,412810,849215,669270,236317,122022,65581,334367,921693,638737,912104,755699,885041,124006,571026,710176,601293,740896,577702,801226,682471,38292,305274,67084,59838,1011344,273433,218972,202420,43606,186537,56017,577123,971626,806556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001644s ]