SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418570 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418570 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110456,670131,224460,935042,262561,25387,1004600,678675,754119,213984,818109,575067,452721,250448,443721,974148,124381,286843,1047113,985597,208302,931016,72177,490889,856045,259635,762651,554456,49633,406670,47852,1011621,749276,965337,764668,529290,922004,869746,961931,817485,29366,79689,823376,559700,1041215,848982,273379,764794,608465,388948,133629,843391,663001,235564,869692,570737,343744,193303,712661,725940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]