SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487183 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487183 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029346,84494,575260,703281,871495,913642,594440,76945,571840,184685,576964,146951,730688,136560,105394,767404,62677,830417,233108,550345,749318,649744,70974,779787,932632,796984,719770,366545,646228,87285,825314,427670,1008001,711079,180269,596604,264323,830387,437266,767118,363954,28120,971429,1022595,337602,363159,221450,383192,605313,495364,679176,1016055,617482,838467,485063,274174,96167,959381,833692,868851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]