SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020602 LIMIT 1 [ RunTime:0.002219s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020602 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212297,231766,669313,152118,615231,377779,871068,217642,484944,165431,192254,780714,338704,154695,917874,459787,702737,16911,543055,22418,321503,156186,1037256,8626,432175,277038,396079,880328,337506,797246,571208,647679,451974,986454,294664,680578,373749,799160,762994,147313,466583,404308,381738,437885,88455,757739,834216,232777,671194,624708,863915,856472,830164,470673,458490,992015,775007,478537,297183,863076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]