SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327140 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327140 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016389,405019,52280,523487,519985,378141,90631,403770,889027,644663,715939,29255,627022,241162,922952,366377,300666,158735,532842,807952,552982,919372,1040191,533734,555521,782498,737944,170478,619565,725380,591430,641658,146297,145338,1047794,299215,590803,283256,245556,859504,905112,301986,346816,408298,10332,589718,965009,665676,933965,132032,141608,437580,679361,744912,1009299,83374,633634,793259,25460,498195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]