SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579053 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579053 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026916,383653,631393,528528,695955,597954,154624,776708,477904,999309,820248,554973,546668,545339,923616,498368,398794,893670,359713,199742,456981,775238,229866,262591,149884,547212,83836,646888,787118,577921,769251,323657,482473,845114,999292,488241,325393,589623,623214,129686,237145,80016,869202,695927,840958,922853,506222,422448,898092,353801,506859,767808,697176,634137,218583,642778,221454,903337,29617,147960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003743s ]