SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330601 LIMIT 1 [ RunTime:0.000863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330601 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913768,920963,728073,13185,670017,152793,238433,56214,774491,242332,264133,473137,62162,1012912,823180,923548,1032981,596547,601755,821431,776127,685153,261850,315234,827961,258505,477310,456236,410896,574529,397669,1046488,617973,196277,628054,901249,48274,643140,392498,65215,594680,908385,387798,495061,160134,330261,980598,969234,235279,649724,109287,826717,1043786,666068,595457,164355,362323,75888,1027478,111200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]