SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48208 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48208 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902461,685520,857520,85578,797314,549649,634006,348905,717807,204174,766821,936196,405203,98992,782149,594796,611690,169243,284585,306292,908923,527505,701845,6244,766797,534026,730873,202808,98130,851322,277145,688035,402982,463224,391821,729900,260689,364194,553361,415018,257589,410172,85441,169016,779322,261983,721742,600287,660665,522529,408803,621892,671921,58,704175,214827,674682,614477,923477,1031289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]