SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203109 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203109 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547587,417610,218462,268367,534424,931866,758793,65234,1035351,751458,1027344,113775,768646,425760,197144,801450,1025868,816263,105473,453857,808034,44842,710186,879560,958757,101264,626401,84859,197684,472977,324219,879130,531583,896157,934095,684950,934088,762209,1038025,229351,555993,1001428,258650,939319,1010031,589588,132670,677634,482689,742319,291005,206216,272011,1036762,692694,601185,361313,713543,189613,791722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]