SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648080 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648080 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646390,512107,792728,301616,598918,89717,477968,1039432,444385,50742,470948,786357,586238,968130,881173,219001,320088,839328,9107,799083,380580,481797,365175,730705,261900,554524,74688,828396,288252,944904,984169,1029216,216787,245891,291150,107548,186970,318475,334509,791123,57225,1002473,204416,884141,559850,826124,307542,177263,191593,309780,964970,92267,660975,838495,1018607,287376,23958,589875,921910,420731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002356s ]