SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455732 LIMIT 1 [ RunTime:0.003451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455732 [ RunTime:0.006604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340508,528510,702304,274740,624131,656956,589512,991295,862659,660559,704750,122746,627495,49976,592333,506855,618450,301400,801689,982792,878076,856914,903825,437120,643663,653429,790755,554302,852390,482903,284943,556148,722265,1011127,325685,121959,562354,652133,919631,914374,242925,574180,579786,61330,889083,872655,647537,408495,957985,662935,522546,92944,235031,160447,639395,678037,954570,148943,478961,257735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003953s ]