SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317760 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317760 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552650,388378,632717,698773,791751,916348,256116,282489,548025,165414,916561,450030,358125,915037,350323,64153,670004,533267,586515,635316,277396,839135,441503,47571,690546,217031,250792,854698,222245,731527,231421,148638,72498,920449,375919,40706,79443,301881,1001554,752366,364853,148044,551298,764203,423513,730082,1016818,200598,759253,694577,253136,271754,131917,705780,963830,769538,236429,613237,668702,322976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]