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` = 474843 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474843 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21590,624709,422080,1004615,789298,704611,107777,722724,37723,260748,202354,170484,448414,367574,247210,878152,622921,161105,490747,819256,490414,587612,199097,411978,501973,311954,281350,926277,188230,275560,343574,299454,889082,153971,629649,618933,545719,178032,508152,394678,64026,776252,1020684,762732,699083,792120,212996,933541,582138,926591,158583,229621,789233,479844,1024768,720756,901071,836043,483563,83063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]