SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201100 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201100 [ RunTime:0.003958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000836,590165,883947,658310,998848,915262,205540,599702,130479,246819,971790,83426,162470,922294,398003,873683,625857,615498,926560,536050,455116,724217,881926,245548,707562,903228,177577,381840,1009780,731957,242207,962646,548929,413828,539642,102002,860844,131602,75083,546672,316718,126896,421238,188095,564371,109922,216572,781921,772423,963263,167659,997412,554329,126038,207057,958467,1005240,724127,477105,227705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]