SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026850 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026850 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736939,905764,897288,329367,882912,810947,550711,655338,55351,56384,994709,206448,407151,602069,735114,649528,463702,613785,6730,211195,595281,19710,679399,89082,449148,842041,952069,871254,654216,87498,912625,475454,329204,991799,116497,309007,961461,662633,277499,901325,577375,866892,671828,851485,903620,555394,625917,5702,560720,470469,656353,588027,846432,223395,678273,498557,19,120283,35967,1007130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]