SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464827 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464827 [ RunTime:0.003462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719044,385272,741187,900604,1021505,661414,498490,222576,569603,754808,629163,395752,891514,872394,900260,101390,106793,418193,331964,525460,98071,105450,248491,83898,48332,784110,673425,921917,51410,7752,864877,251727,812367,818927,633617,44671,307931,220297,380191,286261,243336,643108,853772,87821,198801,965361,791460,10450,562656,863943,11182,645158,367581,876314,616819,779241,750220,338472,56802,859427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]