SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521501 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521501 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413322,238309,342391,518683,269906,351598,818989,95038,882014,256314,162635,381433,733445,164024,653706,976560,929884,827756,520290,326783,935346,612541,870023,205513,281273,322962,544396,796101,811486,391493,369704,517495,605839,493199,506153,994212,756743,717666,279616,536723,115599,794672,696963,43264,247800,759327,688517,644662,702867,917589,292977,478260,165107,1003406,357977,732314,742427,857921,262005,231732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]