SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037078 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037078 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003732,259403,183765,793851,486861,126631,1018434,245078,1015152,241322,893586,553299,94044,578776,727586,617547,945983,488491,372984,928000,1007886,140636,671341,905489,770721,637137,796837,391260,50399,284949,340230,951479,323055,451456,380263,450951,855672,1044714,280547,751652,818518,284869,373963,344497,694217,1043123,15738,32442,946628,245384,527537,705253,993373,585780,249875,83349,120614,933618,993618,31791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]