SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022638 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022638 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597350,843445,549857,847002,132789,708295,994640,1027442,282383,680404,1012758,231905,175880,514739,123590,481040,624332,999915,751509,460470,51591,696958,87464,527778,515033,865401,123329,17719,396901,880103,170816,995780,232188,729252,555069,367865,313878,896651,865743,637935,321144,440367,757047,81655,898705,401842,710722,955609,770800,1043281,611184,421320,446460,609314,856032,10550,202666,703354,222610,336257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]