SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045170 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045170 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315863,806609,159388,833846,746532,371326,465887,559850,1000783,875094,246398,679235,558527,877543,796502,964084,350921,743918,550135,470224,568981,177632,1038107,99391,612408,604367,551259,1044673,934696,520194,101515,177797,106323,519195,784762,253215,163270,935246,1048670,925114,377530,785583,36507,394657,101951,718141,968939,368492,538555,440891,311310,73627,424063,216270,878216,422063,712524,907653,882350,279751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]