SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420082 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420082 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77099,563870,197068,1039952,22651,140713,607175,910289,12296,582151,768865,217654,606391,717847,721471,652014,342253,705754,1034307,254637,106531,983506,999028,410388,824626,478849,1021879,390979,710823,684015,773631,656901,498717,869206,246633,946955,594705,422071,937873,740544,550788,303214,544409,525479,649135,656737,501832,754302,516924,529895,849949,476818,22847,323112,8819,1035579,708032,506621,830176,120150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]