SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417653 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417653 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100384,44130,167930,282767,615128,902843,1005221,4570,23195,826209,945485,731561,673439,288359,68551,4856,1028047,87956,650627,244662,459256,413008,75272,1040876,311705,20387,743808,703463,895846,683752,483973,102185,934580,444472,31806,851973,586813,752709,334265,179630,8225,976925,561029,890327,662399,507036,369070,151225,869586,340823,707303,850169,423888,155043,964596,574020,195275,361116,75723,230651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]