SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531445 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531445 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403008,609703,556066,298664,415653,974927,391313,746265,529398,644544,483347,975987,804794,325131,1034359,776260,982366,1020824,237807,840107,537820,807734,123864,465304,912880,827368,564602,758656,684079,184456,144635,732686,299582,416236,278087,385951,915648,996039,745098,664683,484001,727818,143247,68591,656568,438653,739830,341798,639097,282082,144495,573500,85629,663626,517889,829732,573394,958065,231236,345000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]