SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440766 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440766 [ RunTime:0.003507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14433,265788,382407,563183,307467,758085,504062,437294,530498,601211,530063,112072,752836,86428,735010,420223,512805,101549,720172,941859,878438,902396,1006931,664950,313712,718797,670978,372115,964928,43234,319024,218851,46907,668663,699809,337476,889359,530605,662516,705525,923312,930538,215888,129054,1008521,139585,675597,502540,758806,309139,925084,360495,895116,411825,1032729,231443,624304,853299,1022334,820682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]