SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820173 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820173 [ RunTime:0.004554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439259,451432,762826,390368,766289,301794,751004,466849,840291,621553,841878,472901,1024708,867739,327579,197341,761233,295666,470797,132031,820571,197392,980397,291794,1029225,720163,115541,652332,524753,504585,285881,351221,534732,215451,323780,824047,468319,200262,441027,7441,343361,206097,508729,199948,483056,395935,299051,429671,773870,632996,313754,985366,717030,92073,787429,308463,277984,621851,338229,497043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002637s ]