SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545584 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545584 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798212,209401,761287,181091,1015427,124091,651166,780900,582307,592584,1004976,597970,532653,691254,697700,742567,442688,72026,203256,178734,426853,1008465,312035,579186,531947,981347,893068,916637,559849,200618,343459,30695,337784,973528,407232,342787,148114,71769,611320,653689,472226,727472,257455,599891,3685,770729,858953,19875,632922,926238,747166,611604,536401,626625,970618,184716,122483,884273,990145,187673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]