SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416062 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416062 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680058,981548,778279,281547,936987,435247,583956,245908,615948,397623,710515,423516,21062,402286,779239,748916,304675,407781,987995,546574,582163,568218,989291,448052,195988,699532,202572,315025,86563,916554,145557,824355,352943,678838,273006,518752,580760,243465,757139,767418,349339,210851,296491,867035,972303,178350,694932,26073,322094,229866,829385,70586,1011967,101428,10651,924941,442202,614828,459603,296815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]