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` = 1014500 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014500 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103447,660125,868995,632213,631484,1014055,522690,741673,358121,362240,722573,898722,426816,323655,1024876,957420,471617,843475,1016212,258009,112058,598825,201382,982860,926031,1001860,901392,341478,86004,791737,993939,749085,818479,997806,734132,587286,644486,248621,22735,897134,730194,897254,482022,371450,705547,325658,532157,132718,59645,443350,133955,480001,673923,96974,902704,422082,329800,110275,198298,825357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]