SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526838 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526838 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316680,836041,685417,808370,799608,778910,926417,175181,231041,277400,359361,607937,1008232,349029,707054,489539,621887,836611,856915,473008,768960,946187,684569,1016348,316971,769439,522704,511043,640738,994847,327335,977941,15987,401200,89555,557041,573026,961317,154849,343071,864534,869561,607261,333333,451643,469752,935123,40993,940453,39262,27637,651692,775756,806896,751115,579986,577405,15532,756500,1004932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]