SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382878 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382878 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395459,1023568,311031,369077,395631,1048280,231338,831473,876346,661210,634901,596376,871820,611412,35008,300480,537726,745201,410327,60780,829536,406126,871785,2134,788218,586061,830365,61529,829699,826301,448717,338986,649173,256327,1034862,455786,354903,653325,618545,502731,698743,423275,68692,206302,377568,412892,920133,394140,167286,358303,146990,62441,499155,378748,296064,259435,318163,302887,289732,187998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]