SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108610 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108610 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826573,1011462,884714,71839,479694,522370,795503,479707,865471,374477,106032,212678,940374,971598,929855,638471,681195,1023676,919948,455247,31189,883164,972740,504366,468695,141057,1013409,629043,1040521,236345,541976,540945,716539,947800,348729,882516,54928,644327,37270,504182,651104,376017,917035,607331,874814,89359,824652,541156,887911,123911,132539,314692,683964,653557,1021979,119994,223866,860059,463383,28695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]