SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516806 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516806 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368992,316639,322725,1106,842644,639076,226351,402567,920481,919254,853662,381483,375531,665933,283223,370408,707128,22582,380486,74296,915892,721811,964963,376294,354779,763472,563837,546115,333572,976681,836694,732824,919728,639721,1008659,227400,164259,736115,323195,515155,173707,457095,83888,823163,560739,376548,20027,312673,221543,221975,1048117,706257,571957,19451,573571,440237,855498,526718,337526,998884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]