SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505521 LIMIT 1 [ RunTime:0.004172s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505521 [ RunTime:0.003701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489969,744831,322388,1766,1041710,41234,896137,519746,356231,577454,595551,52808,308548,521744,250534,1033323,485678,334475,806604,656553,698118,542744,843549,783562,200599,247569,1031283,228448,8014,141921,88657,759774,804148,163088,371265,847891,861787,990512,613317,254557,127604,166377,945580,146719,827888,22426,8831,943684,570328,128558,799793,194418,313425,459296,239001,215488,1023229,483804,210118,259572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]