SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213658 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213658 [ RunTime:0.003934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530207,56703,85023,362290,511296,791300,1036038,196971,106585,154147,558841,561609,158002,139504,599044,169683,133467,778753,600746,383503,392537,113417,142701,815527,312022,129344,946096,499368,668003,1029821,181740,282843,219502,498226,3193,89970,730634,321393,394302,326928,273284,573938,977302,40886,707243,1019983,314952,482008,225844,484018,43313,264193,358124,555130,618899,777128,182414,552908,853415,715118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]