SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336683 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336683 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664153,275657,595918,675001,286461,127477,909867,629727,606703,204025,568834,496686,187356,387745,740825,96202,883623,567965,815110,592889,617839,637310,389123,746511,358296,1004563,30339,740146,954995,439369,29481,351431,368833,714167,403414,857057,735375,89793,315291,296589,748998,586699,253482,761934,37707,1014557,861981,921029,1025584,834736,201474,987506,128316,481907,843120,445680,348905,399675,655497,954968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003003s ]