SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583821 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583821 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439272,489973,738693,350513,246177,129600,738627,547215,581834,704773,98953,339247,40982,221527,326960,833595,529944,635616,429161,633704,614234,835335,307480,230286,64212,89173,259915,484155,779519,482714,134016,1014813,158484,1037199,270532,812952,740925,967767,948501,529606,1040936,730580,498865,144391,413188,581239,631303,488501,516826,193370,31177,854308,659245,705696,52399,65646,759559,932368,154160,406272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003718s ]