SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43305 LIMIT 1 [ RunTime:0.000996s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43305 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342042,874348,584178,342126,704656,820039,441258,13093,537951,922040,547350,438638,834375,760032,786926,730634,547492,777547,671115,945291,164351,635878,292221,1043542,665165,460000,738335,85482,83419,480568,88642,857510,961844,602709,41581,983956,753795,6863,785074,450984,87122,910070,252084,510265,280887,1014200,655467,340204,676362,269933,122272,996965,741116,345246,257300,95540,523305,581252,1030415,975471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]