SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551043 LIMIT 1 [ RunTime:0.003136s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551043 [ RunTime:0.003452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515576,277286,443509,850257,168540,514004,508360,964883,33323,420188,69815,260912,814968,90319,624982,693400,690715,224950,1040496,987008,1040334,949572,385632,121372,12079,122575,375461,327431,343416,495968,362278,261521,865556,41459,74594,15222,282555,210111,50587,395552,162402,186221,151078,853436,494522,853527,966110,675803,48208,469229,499097,644103,535398,19592,920114,870276,511055,297649,634298,798423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002557s ]