SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346015 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346015 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436628,653435,777063,550078,160812,153087,50942,944190,926487,684152,5041,89709,52971,412885,269585,761659,392273,263756,918438,778013,727851,853357,851541,82014,377134,707415,241110,748625,769161,220780,379918,5769,847789,521608,522029,73079,890266,691563,985345,191245,227608,905260,480023,573482,252865,905270,34885,736437,151217,906302,904673,45534,857512,1008153,744024,758504,538705,1040798,74714,70286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]