SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104118 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104118 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452002,218974,844791,940327,160342,199064,386113,563595,385825,835308,554925,682674,461359,392637,860746,182988,607771,288850,270138,863619,507440,200836,203293,193061,944779,289689,367261,173023,524246,921614,686395,867343,461976,670495,394176,614646,965387,1011824,521957,937713,149461,855783,419807,477224,956025,7512,34250,785878,700018,510684,399269,591511,18577,290882,705879,942299,504098,571134,376577,9798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]