SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037270 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037270 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454509,808685,358330,465549,541338,881766,358370,592010,223626,452319,205069,73090,710765,404207,189795,791689,534929,267593,409902,867701,128271,217987,220056,718831,403335,606479,887464,258935,26482,858729,385008,909468,894488,809705,761351,496951,375837,528703,856608,897620,767023,166246,94551,607772,946047,284383,71801,685438,771872,674745,179046,726948,160356,306642,69545,783402,978986,40037,162879,424840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]