SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675601 LIMIT 1 [ RunTime:0.001425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675601 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744132,496740,577225,435373,201271,716673,902276,636757,494416,244496,786446,152247,199283,772375,446201,678320,912433,498018,1018297,853274,925086,156727,35700,32466,550475,605565,856985,15846,968718,392387,922471,279580,923102,61697,616813,515986,20096,486735,697307,646609,853714,1045669,1048022,334009,270094,116000,707750,148382,952404,341855,626545,582833,1037564,714310,21135,75864,156635,915541,246483,872868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]