SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533105 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533105 [ RunTime:0.004945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932272,408098,24507,870839,454563,528059,403191,951916,1007399,557378,147080,262589,1042666,921872,669969,912994,449742,1040048,746332,623917,57209,510734,651878,445923,34151,65397,217401,428664,802907,23207,768851,78760,825775,105683,145882,944917,69279,108580,470238,930993,809023,693400,501017,397540,295808,737946,263780,513476,79461,190582,514313,347981,182535,735435,194917,587394,125559,334998,667040,547260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]